﻿CREATE PROCEDURE [dbo].[ContragentsSelect]
AS
	SET NOCOUNT ON;
SELECT Id, GId, Name, ShortName, IsSeller, IsCustomer, IsSertification, EMail, Phone, 
DirectorFIO, DirectorPosition, Note, FirmType, JuridicalAddress, INN, KPP, OKPO, OKONX, 
SettlementAccount, Bank, BIK, CorrespondentAccount, ActualAddress, Fax, WebPage, ICQ, MD, MW 
FROM CA.Contragents
